import matplotlib.pyplot as plt
import pandas as pd
df = pd.read_excel('学生各学期成绩表.xlsx')
x = df['序号']
y = df['语文']
plt.plot(x, y)
plt.figure('学生成绩', (5, 4), facecolor='red')
plt.plot(x, y)
plt.show()